*
* Purpose: prepare per capita gross annual income on the settlement level
* Note: average HUF/USD exchange rate in 2007 was 183 HUF/USD (www.mnb.hu)
*

use "${settlement_level_income_raw}.dta", clear

gen grossincome = tx02/tx01/183

rename ev year
keep tazon year grossincome
keep if year == 2007

lab var tazon "Settlement identifier"
lab var year "Year"
lab var grossincome "Per-capita gross annual income"

save "C:/Users/User/Dropbox/Large_Core/data/Income.dta", replace
